Kelly Drake
Kelly Drake
Reactions
-
Re: In access request alerts please include a second button to share the workspace
YESSS! I had to remove all the admins from my workspaces with this change that made it easier for sysadmins but hosed solution engineers. 🤬🤦♀️1 · -
Re: Turn cell Green, Yellow or red depending on how many days have elapsed past a date in another column
To turn the cell colors, you would need a helper column to trigger conditional formatting. This formula could work using a RYGB ball column type as your helper =IF(NOT(ISBLANK([Column B]@row)), "…1 · -
Re: How Can I Connect a string of IF/AND and ISBLANK statements Into a Working Formula?
I think part of the issue you're running into is too many parentheses. You do not need to wrap ISBLANK inside parentheses. It was also giving me a weird error with the two cells being blank at the en…1 · -
Re: VLOOKUP when text contains special characters
INDEX/MATCH is more optimized for Smartsheet and I'd recommend transitioning to that formula where you can. Just to make sure I'm understanding here's your set up: Sheet A - Column 1 = Project Name S…1 · -
Re: VLOOKUP on a reference sheet gives me a "no match" headache
3 quick recommendations: Change the names of your cell references so you can quickly ID what the formula is looking at. I would also recommend that you replace VLOOKUP with an INDEX/MATCH since that'…1 ·
